﻿CREATE TABLE [dbo].[HansardSections] (
    [Id]                                            NVARCHAR (100) NOT NULL,
    [PublicationStatus]                             NVARCHAR (MAX) NOT NULL,
    [Date]                                          DATETIME       NOT NULL,
    [Fragment]                                      INT            NOT NULL,
    [Title]                                         NVARCHAR (MAX) NOT NULL,
    [IndexedContent]                                NVARCHAR (MAX) NOT NULL,
    [TranscriptPDFLink]                             NVARCHAR (MAX) NULL,
    [Context]                                       NVARCHAR (MAX) NOT NULL,
    [Type]                                          NVARCHAR (MAX) NOT NULL,
    [ParliamentNumber]                              INT            NOT NULL,
    [SpeakerNames]                                  NVARCHAR (MAX) NULL,
    [SpeakerIds]                                    NVARCHAR (MAX) NULL,
    [QuestionerNames]                               NVARCHAR (MAX) NULL,
    [QuestionerIds]                                 NVARCHAR (MAX) NULL,
    [ResponderNames]                                NVARCHAR (MAX) NULL,
    [ResponderIds]                                  NVARCHAR (MAX) NULL,
    [InterjectorNames]                              NVARCHAR (MAX) NULL,
    [InterjectorIds]                                NVARCHAR (MAX) NULL,
    [PresenterNames]                                NVARCHAR (MAX) NULL,
    [PresenterIds]                                  NVARCHAR (MAX) NULL,
    [FullTranscriptId]                              NVARCHAR (100) NOT NULL,
    [SectionHTMLLink]                               NVARCHAR (MAX) NOT NULL,
    [HansardGenericSearchResult_Hansard_Id]         NVARCHAR (100) NOT NULL,
    [Inquiry_Id]                                    NVARCHAR (100) NULL,
    [ParliamentarianFirstSpeech_HansardSection_Id]  NVARCHAR (100) NULL,
    [Bill_Id]                                       NVARCHAR (100) NULL,
    [BillSecondReadingSpeeches_HansardSection_Id]   NVARCHAR (100) NULL,
    [BillMinisterOrSponsorSpeech_HansardSection_Id] NVARCHAR (100) NULL,
    [BillSpeechesOnConsideration_HansardSection_Id] NVARCHAR (100) NULL,
    [SectionTranscript_Id]                          NVARCHAR (100) NOT NULL,
    [BillFirstReadingSpeeches_HansardSection_Id]    NVARCHAR (100) NULL
);













